<!DOCTYPE html>
<!-- saved from url=(0039)https://www.dswjcms.com/Manual/p2p.html -->
<html lang="zh-CN">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>p2p数据库词典</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="IE=9">
    <!--[if lt IE 9 ] ><META http-equiv="X-UA-Compatible" content="IE=8" ></META><![endif]-->
    <link href="bootstrap.min.css" rel="stylesheet">
    <link href="bootstrap-responsive.min.css" rel="stylesheet">
    <link href="/manual.css" rel="stylesheet">
    <script src="jquery-1.7.2.min.js"></script>
</head>
<body><!--start: Navigation -->

    <div class="row content"><!--系统配置-->
        <table class="table table-bordered">
            <caption>system(系统配置<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>smallint(6)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>state</td>
                <td>varchar(25)</td>
                <td>参数说明</td>
            </tr>
            <tr>
                <td>prompt</td>
                <td>varchar(30)</td>
                <td>输入提示</td>
            </tr>
            <tr>
                <td>value</td>
                <td>varchar(255)</td>
                <td>参数值</td>
            </tr>
            <tr>
                <td>name</td>
                <td>varchar(255)</td>
                <td>变量名</td>
            </tr>
            <tr id="user">
                <td>type</td>
                <td>tinyint(1)</td>
                <td>表单类型</td>
            </tr>
            </tbody>
        </table><!--系统配置 end--><!--用户表-->
        <table class="table table-bordered">
            <caption>user(用户表<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>int(11)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>uid</td>
                <td>int(11)</td>
                <td>上线ID</td>
            </tr>
            <tr>
                <td>username</td>
                <td>varchar(16)</td>
                <td>用户名</td>
            </tr>
            <tr>
                <td>email</td>
                <td>varchar(255)</td>
                <td>邮箱</td>
            </tr>
            <tr>
                <td>password</td>
                <td>char(32)</td>
                <td>密码</td>
            </tr>
            <tr>
                <td>pay_password</td>
                <td>char(32)</td>
                <td>支付密码</td>
            </tr>
            <tr>
                <td>pid</td>
                <td>int(11)</td>
                <td>上级用户</td>
            </tr>
            <tr id="admin">
                <td>time</td>
                <td>int(11)</td>
                <td>注册时间</td>
            </tr>
            </tbody>
        </table><!--用户表 end--><!--管理员表-->
        <table class="table table-bordered">
            <caption>admin(管理员表<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>int(11)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>username</td>
                <td>varchar(16)</td>
                <td>用户名</td>
            </tr>
            <tr>
                <td>email</td>
                <td>varchar(255)</td>
                <td>邮箱</td>
            </tr>
            <tr>
                <td>password</td>
                <td>char(32)</td>
                <td>密码</td>
            </tr>
            <tr id="userinfo">
                <td>time</td>
                <td>int(11)</td>
                <td>注册时间</td>
            </tr>
            </tbody>
        </table><!--管理员表 end--><!--用户信息表-->
        <table class="table table-bordered">
            <caption>userinfo(用户信息表<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>int(11)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>uid</td>
                <td>int(11)</td>
                <td>会员ID</td>
            </tr>
            <tr>
                <td>name</td>
                <td>varchar(13)</td>
                <td>真实姓名</td>
            </tr>
            <tr>
                <td>gender</td>
                <td>tinyint(1)</td>
                <td>0男1女</td>
            </tr>
            <tr>
                <td>national</td>
                <td>smallint(2)</td>
                <td>民族</td>
            </tr>
            <tr>
                <td>born</td>
                <td>int(11)</td>
                <td>出生日期</td>
            </tr>
            <tr>
                <td>idcard</td>
                <td>varchar(18)</td>
                <td>身份证</td>
            </tr>
            <tr>
                <td>idcard_img</td>
                <td>varchar(50)</td>
                <td>身份证证明</td>
            </tr>
            <tr>
                <td>native_place</td>
                <td>varchar(23)</td>
                <td>籍贯</td>
            </tr>
            <tr>
                <td>location</td>
                <td>varchar(23)</td>
                <td>所在地</td>
            </tr>
            <tr>
                <td>marriage</td>
                <td>tinyint(1)</td>
                <td>婚姻状况</td>
            </tr>
            <tr>
                <td>education</td>
                <td>tinyint(2)</td>
                <td>学历</td>
            </tr>
            <tr>
                <td>monthly_income</td>
                <td>tinyint(2)</td>
                <td>月收入</td>
            </tr>
            <tr>
                <td>housing</td>
                <td>tinyint(1)</td>
                <td>住房条件</td>
            </tr>
            <tr>
                <td>buy_cars</td>
                <td>tinyint(1)</td>
                <td>购车情况</td>
            </tr>
            <tr>
                <td>industry</td>
                <td>tinyint(2)</td>
                <td>行业</td>
            </tr>
            <tr>
                <td>company</td>
                <td>varchar(15)</td>
                <td>公司</td>
            </tr>
            <tr>
                <td>qq</td>
                <td>varchar(12)</td>
                <td>QQ</td>
            </tr>
            <tr>
                <td>bank</td>
                <td>smallint(3)</td>
                <td>开户银行</td>
            </tr>
            <tr>
                <td>bank_name</td>
                <td>varchar(30)</td>
                <td>开户支行名称</td>
            </tr>
            <tr>
                <td>bank_account</td>
                <td>varchar(19)</td>
                <td>银行账号</td>
            </tr>
            <tr>
                <td>fixed_line</td>
                <td>varchar(15)</td>
                <td>固话</td>
            </tr>
            <tr>
                <td>cellphone</td>
                <td>varchar(11)</td>
                <td>手机</td>
            </tr>
            <tr>
                <td>certification</td>
                <td>tinyint(1)</td>
                <td>实名认证</td>
            </tr>
            <tr>
                <td>email_audit</td>
                <td>tinyint(1)</td>
                <td>邮箱认证</td>
            </tr>
            <tr>
                <td>cellphone_audit</td>
                <td>tinyint(1)</td>
                <td>手机认证</td>
            </tr>
            <tr>
                <td>video_audit</td>
                <td>tinyint(1)</td>
                <td>视频认证</td>
            </tr>
            <tr id="membership_grade">
                <td>site_audit</td>
                <td>tinyint(1)</td>
                <td>现场认证</td>
            </tr>
            </tbody>
        </table><!--用户信息表 end--><!--会员等级表-->
        <table class="table table-bordered">
            <caption>membership_grade(会员等级表（暂时无用）)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>int(11)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>name</td>
                <td>varchar(16)</td>
                <td>等级名</td>
            </tr>
            <tr>
                <td>img</td>
                <td>varchar(30)</td>
                <td>图标</td>
            </tr>
            <tr>
                <td>min</td>
                <td>int(11)</td>
                <td>分值（最小）</td>
            </tr>
            <tr id="money">
                <td>max</td>
                <td>int(11)</td>
                <td>分值（最大）</td>
            </tr>
            </tbody>
        </table><!--会员等级表 end--><!--资金表-->
        <table class="table table-bordered">
            <caption>money(资金表<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>int(11)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>uid</td>
                <td>int(11)</td>
                <td>会员ID</td>
            </tr>
            <tr>
                <td>total_money</td>
                <td>decimal(20,10)</td>
                <td>总资金</td>
            </tr>
            <tr>
                <td>available_funds</td>
                <td>decimal(20,10)</td>
                <td>可用资金</td>
            </tr>
            <tr>
                <td>freeze_funds</td>
                <td>decimal(20,10)</td>
                <td>冻结资金</td>
            </tr>
            <tr>
                <td>due_in</td>
                <td>decimal(20,10)</td>
                <td>待收资金</td>
            </tr>
            <tr>
                <td>stay_still</td>
                <td>decimal(20,10)</td>
                <td>待还资金</td>
            </tr>
            <tr>
                <td>stay_interest</td>
                <td>decimal(20,10)</td>
                <td>待收利息</td>
            </tr>
            <tr>
                <td>make_interest</td>
                <td>decimal(20,10)</td>
                <td>已赚利息</td>
            </tr>
            <tr>
                <td>make_reward</td>
                <td>decimal(15,2)</td>
                <td>已赚奖励</td>
            </tr>
            <tr id="unite">
                <td>overdue</td>
                <td>decimal(20,10)</td>
                <td>逾期金额</td>
            </tr>
            </tbody>
        </table><!--资金表 end--><!--联动表-->
        <table class="table table-bordered">
            <caption>unite(联动表<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>mediumint(8)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>state</td>
                <td>tinyint(1)</td>
                <td>0显示1隐藏</td>
            </tr>
            <tr>
                <td>pid</td>
                <td>mediumint(8)</td>
                <td>所属联动</td>
            </tr>
            <tr>
                <td>name</td>
                <td>varchar(15)</td>
                <td>联动名</td>
            </tr>
            <tr>
                <td>value</td>
                <td>varchar(15)</td>
                <td>联动值</td>
            </tr>
            <tr id="borrowing">
                <td>order</td>
                <td>mediumint(8)</td>
                <td>排序</td>
            </tr>
            </tbody>
        </table><!--联动表 end--><!--借款表-->
        <table class="table table-bordered">
            <caption>borrowing(借款表<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>int(11)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>uid</td>
                <td>int(11)</td>
                <td>用户名</td>
            </tr>
            <tr>
                <td>type</td>
                <td>tinyint(2)</td>
                <td>标类别</td>
            </tr>
            <tr>
                <td>title</td>
                <td>varchar(25)</td>
                <td>标题</td>
            </tr>
            <tr>
                <td>rates</td>
                <td>decimal(4,2)</td>
                <td>利率</td>
            </tr>
            <tr>
                <td>use</td>
                <td>tinyint(2)</td>
                <td>借款用途</td>
            </tr>
            <tr>
                <td>deadline</td>
                <td>tinyint(2)</td>
                <td>借款期限</td>
            </tr>
            <tr>
                <td>candra</td>
                <td>tinyint(1)</td>
                <td>计息模式</td>
            </tr>
            <tr>
                <td>way</td>
                <td>tinyint(1)</td>
                <td>还款方式</td>
            </tr>
            <tr>
                <td>valid</td>
                <td>tinyint(2)</td>
                <td>有效时间</td>
            </tr>
            <tr>
                <td>code</td>
                <td>tinyint(1)</td>
                <td>密码标0关1开</td>
            </tr>
            <tr>
                <td>password</td>
                <td>char(32)</td>
                <td>密码</td>
            </tr>
            <tr>
                <td>min</td>
                <td>varchar(10)</td>
                <td>最低投标金额</td>
            </tr>
            <tr>
                <td>max</td>
                <td>varchar(10)</td>
                <td>最高投标金额</td>
            </tr>
            <tr>
                <td>money</td>
                <td>decimal(15,2)</td>
                <td>借款金额</td>
            </tr>
            <tr>
                <td>surplus</td>
                <td>decimal(15,2)</td>
                <td>还需借款金额</td>
            </tr>
            <tr>
                <td>data</td>
                <td>varchar(600)</td>
                <td>资料证明</td>
            </tr>
            <tr>
                <td>content</td>
                <td>text</td>
                <td>借款说明</td>
            </tr>
            <tr>
                <td>state</td>
                <td>tinyint(2)</td>
                <td>状态</td>
            </tr>
            <tr>
                <td>review_note</td>
                <td>varchar(200)</td>
                <td>审核备注</td>
            </tr>
            <tr>
                <td>time</td>
                <td>int(11)</td>
                <td>发标时间</td>
            </tr>
            <tr>
                <td>stick</td>
                <td>tinyint(1)</td>
                <td>0不推荐1推荐</td>
            </tr>
            <tr>
                <td>checktime</td>
                <td>int(11)</td>
                <td>审核时间</td>
            </tr>
            <tr>
                <td>endtime</td>
                <td>int(11)</td>
                <td>失效时间</td>
            </tr>
            <tr>
                <td>reviewtime</td>
                <td>int(11)</td>
                <td>复审时间</td>
            </tr>
            <tr>
                <td>limittime</td>
                <td>int(11)</td>
                <td>逾期时间</td>
            </tr>
            <tr>
                <td>reward</td>
                <td>decimal(5,2)</td>
                <td>奖励值</td>
            </tr>
            <tr id="city">
                <td>reward_type</td>
                <td>tinyint(1)</td>
                <td>奖励类型</td>
            </tr>
            </tbody>
        </table><!--借款表 end--><!--城市表-->
        <table class="table table-bordered">
            <caption>city(城市表<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>mid</td>
                <td>mediumint(8)</td>
                <td>父ID</td>
            </tr>
            <tr>
                <td>city</td>
                <td>varchar(100)</td>
                <td>城市名</td>
            </tr>
            <tr id="user_log">
                <td>var</td>
                <td>varchar(80)</td>
                <td>城市值(主键)</td>
            </tr>
            </tbody>
        </table><!--城市表 end--><!--会员操作记录-->
        <table class="table table-bordered">
            <caption>user_log(会员操作记录<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>int(11)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>uid</td>
                <td>int(11)</td>
                <td>用户名</td>
            </tr>
            <tr>
                <td>actionname</td>
                <td>varchar(40)</td>
                <td>操作名称</td>
            </tr>
            <tr>
                <td>page</td>
                <td>varchar(100)</td>
                <td>操作页面</td>
            </tr>
            <tr>
                <td>time</td>
                <td>int(11)</td>
                <td>操作时间</td>
            </tr>
            <tr id="operation">
                <td>ip</td>
                <td>varchar(20)</td>
                <td>操作IP</td>
            </tr>
            </tbody>
        </table><!--会员操作记录 end--><!--后台操作记录-->
        <table class="table table-bordered">
            <caption>operation(后台操作记录<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>int(11)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>name</td>
                <td>varchar(25)</td>
                <td>操作者</td>
            </tr>
            <tr>
                <td>page</td>
                <td>varchar(50)</td>
                <td>操作页面</td>
            </tr>
            <tr>
                <td>type</td>
                <td>varchar(25)</td>
                <td>操作类型</td>
            </tr>
            <tr>
                <td>ip</td>
                <td>varchar(25)</td>
                <td>操作IP</td>
            </tr>
            <tr id="money_log">
                <td>time</td>
                <td>int(11)</td>
                <td>操作时间</td>
            </tr>
            </tbody>
        </table><!--后台操作记录 end--><!--资金/积分操作记录-->
        <table class="table table-bordered">
            <caption>money_log(资金/积分操作记录<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>int(11)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>uid</td>
                <td>int(11)</td>
                <td>用户名</td>
            </tr>
            <tr>
                <td>type</td>
                <td>tinyint(1)</td>
                <td>操作类型 0资金1会员积分2VIP积分3推广积分</td>
            </tr>
            <tr>
                <td>finetype</td>
                <td>tinyint(2)</td>
                <td>细节类型</td>
            </tr>
            <tr>
                <td>actionname</td>
                <td>varchar(40)</td>
                <td>操作说明</td>
            </tr>
            <tr>
                <td>total_money</td>
                <td>decimal(20,10)</td>
                <td>总金额</td>
            </tr>
            <tr>
                <td>available_funds</td>
                <td>decimal(20,10)</td>
                <td>可用金额</td>
            </tr>
            <tr>
                <td>freeze_funds</td>
                <td>decimal(20,10)</td>
                <td>冻结金额</td>
            </tr>
            <tr>
                <td>operation</td>
                <td>decimal(20,10)</td>
                <td>操作金额</td>
            </tr>
            <tr>
                <td>counterparty</td>
                <td>varchar(16)</td>
                <td>交易对方</td>
            </tr>
            <tr>
                <td>time</td>
                <td>int(11)</td>
                <td>操作时间</td>
            </tr>
            <tr id="borrow_log">
                <td>ip</td>
                <td>varchar(20)</td>
                <td>操作IP</td>
            </tr>
            </tbody>
        </table><!--资金/积分操作记录 end--><!--标操作记录-->
        <table class="table table-bordered">
            <caption>borrow_log(标操作记录<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>int(11)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>bid</td>
                <td>int(11)</td>
                <td>标ID</td>
            </tr>
            <tr>
                <td>uid</td>
                <td>int(11)</td>
                <td>用户ID</td>
            </tr>
            <tr>
                <td>number</td>
                <td>varchar(30)</td>
                <td>流水号</td>
            </tr>
            <tr>
                <td>type</td>
                <td>tinyint(2)</td>
                <td>类型</td>
            </tr>
            <tr>
                <td>actionname</td>
                <td>varchar(800)</td>
                <td>其他参数</td>
            </tr>
            <tr>
                <td>time</td>
                <td>int(11)</td>
                <td>操作时间</td>
            </tr>
            <tr id="smtp">
                <td>ip</td>
                <td>varchar(20)</td>
                <td>操作IP</td>
            </tr>
            </tbody>
        </table><!--标操作记录 end--><!--邮箱smtp设置-->
        <table class="table table-bordered">
            <caption>smtp(邮箱smtp设置<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>tinyint(1)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>smtp</td>
                <td>varchar(255)</td>
                <td>SMTP服务器</td>
            </tr>
            <tr>
                <td>validation</td>
                <td>tinyint(1)</td>
                <td>SMTP验证1是2否</td>
            </tr>
            <tr>
                <td>send_email</td>
                <td>varchar(255)</td>
                <td>email</td>
            </tr>
            <tr>
                <td>password</td>
                <td>varchar(15)</td>
                <td>密码</td>
            </tr>
            <tr id="withdrawal">
                <td>addresser</td>
                <td>varchar(15)</td>
                <td>发件人</td>
            </tr>
            </tbody>
        </table><!--邮箱smtp设置 end--><!--提现表-->
        <table class="table table-bordered">
            <caption>withdrawal(提现表<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>int(11)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>uid</td>
                <td>int(11)</td>
                <td>用户ID</td>
            </tr>
            <tr>
                <td>money</td>
                <td>decimal(10,2)</td>
                <td>提现金额</td>
            </tr>
            <tr>
                <td>name</td>
                <td>varchar(13)</td>
                <td>提现人</td>
            </tr>
            <tr>
                <td>bank</td>
                <td>varchar(30)</td>
                <td>提现银行</td>
            </tr>
            <tr>
                <td>bank_name</td>
                <td>varchar(30)</td>
                <td>提现支行名</td>
            </tr>
            <tr>
                <td>bank_account</td>
                <td>varchar(19)</td>
                <td>提现账户</td>
            </tr>
            <tr>
                <td>withdrawal_poundage</td>
                <td>decimal(10,2)</td>
                <td>手续费</td>
            </tr>
            <tr>
                <td>account</td>
                <td>decimal(10,2)</td>
                <td>到账金额</td>
            </tr>
            <tr>
                <td>time</td>
                <td>int(11)</td>
                <td>提现时间</td>
            </tr>
            <tr>
                <td>type</td>
                <td>tinyint(1)</td>
                <td>审核状态</td>
            </tr>
            <tr>
                <td>handlers</td>
                <td>varchar(16)</td>
                <td>操作者</td>
            </tr>
            <tr id="offline">
                <td>audittime</td>
                <td>int(11)</td>
                <td>审核时间</td>
            </tr>
            </tbody>
        </table><!--提现表 end--><!--线下充值账户-->
        <table class="table table-bordered">
            <caption>offline(线下充值账户<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
            	<td>id</td>
            	<td>smallint(3)</td>
            	<td>主键</td>
            </tr>
			
            <tr>
                <td>type</td>
                <td>smallint(3)</td>
                <td>充值类型</td>
            </tr>
            <tr>
                <td>bank_name</td>
                <td>varchar(30)</td>
                <td>开户支行名称</td>
            </tr>
            <tr>
                <td>name</td>
                <td>varchar(50)</td>
                <td>收款人</td>
            </tr>
            <tr>
                <td>bank</td>
                <td>varchar(25)</td>
                <td>银行账户</td>
            </tr>
            <tr id="online">
                <td>order</td>
                <td>int(11)</td>
                <td>排序</td>
            </tr>
            </tbody>
        </table><!--线下充值账户 end--><!--线上充值账户-->
        <table class="table table-bordered">
            <caption>online(线上充值账户<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>smallint(3)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>name</td>
                <td>value(12)</td>
                <td>支付名称</td>
            </tr>
            <tr>
                <td>logo</td>
                <td>varchar(30)</td>
                <td>LOGO</td>
            </tr>
            <tr>
                <td>pid</td>
                <td>value(16)</td>
                <td>合作者ID</td>
            </tr>
            <tr>
                <td>checking</td>
                <td>varchar(255)</td>
                <td>密钥</td>
            </tr>
            <tr>
                <td>account</td>
                <td>varchar(255)</td>
                <td>收款账户</td>
            </tr>
            <tr>
                <td>introduce</td>
                <td>varchar(200)</td>
                <td>介绍</td>
            </tr>
            <tr>
                <td>state</td>
                <td>tinyint(1)</td>
                <td>状态</td>
            </tr>
            <tr id="recharge">
                <td>order</td>
                <td>smallint(3)</td>
                <td>排序</td>
            </tr>
            </tbody>
        </table><!--线上充值账户 end--><!--账户充值-->
        <table class="table table-bordered">
            <caption>recharge(账户充值<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>int(11)</td>
                <td>主键</td>
            </tr>
			<tr>
				<td>number</td>
				<td></td>
				<td>流水号</td>
			</tr>
            <tr>
                <td>oid</td>
                <td>smallint(3)</td>
                <td>支付方法ID（线下）</td>
            </tr>
            <tr>
                <td>uid</td>
                <td>int(11)</td>
                <td>用户ID</td>
            </tr>
            <tr>
                <td>nid</td>
                <td>varchar(30)</td>
                <td>订单号</td>
            </tr>
            <tr>
                <td>genre</td>
                <td>tinyint(2)</td>
                <td>充值类型</td>
            </tr>
            <tr>
                <td>money</td>
                <td>decimal(10,2)</td>
                <td>充值金额</td>
            </tr>
            <tr>
                <td>poundage</td>
                <td>decimal(6,2)</td>
                <td>手续费</td>
            </tr>
            <tr>
                <td>account_money</td>
                <td>decimal(10,2)</td>
                <td>到账金额</td>
            </tr>
            <tr>
                <td>time</td>
                <td>int(11)</td>
                <td>充值时间</td>
            </tr>
            <tr>
                <td>type</td>
                <td>tinyint(1)</td>
                <td>充值状态</td>
            </tr>
            <tr>
                <td>handlers</td>
                <td>varchar(16)</td>
                <td>操作者</td>
            </tr>
            <tr>
                <td>audittime</td>
                <td>int(11)</td>
                <td>审核时间</td>
            </tr>
            <tr id="instation">
                <td>date</td>
                <td>text</td>
                <td>记录</td>
            </tr>
            </tbody>
        </table><!--账户充值 end--><!--站内信-->
        <table class="table table-bordered">
            <caption>instation(站内信<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>int(11)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>fid</td>
                <td>int(11)</td>
                <td>发件用户ID：0为管理员</td>
            </tr>
            <tr>
                <td>sid</td>
                <td>int(11)</td>
                <td>收件用户ID</td>
            </tr>
            <tr>
                <td>pid</td>
                <td>int(11)</td>
                <td>回复的信息ID</td>
            </tr>
            <tr>
                <td>title</td>
                <td>varchar(30)</td>
                <td>标题</td>
            </tr>
            <tr>
                <td>msg</td>
                <td>varchar(300)</td>
                <td>内容</td>
            </tr>
            <tr>
                <td>state</td>
                <td>tinyint(1)</td>
                <td>0未读1已读2删除</td>
            </tr>
            <tr>
                <td>type</td>
                <td>tinyint(1)</td>
                <td>是否为群发：1是</td>
            </tr>
            <tr id="refund">
                <td>time</td>
                <td>int(11)</td>
                <td>时间</td>
            </tr>
            </tbody>
        </table><!--站内信 end--><!--还款表-->
        <table class="table table-bordered">
            <caption>refund(还款表<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>mediumint</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>nper</td>
                <td>int(11)</td>
                <td>期数</td>
            </tr>
            <tr>
                <td>uid</td>
                <td>int(11)</td>
                <td>用户</td>
            </tr>
            <tr>
                <td>bid</td>
                <td>int(11)</td>
                <td>标ID</td>
            </tr>
            <tr>
                <td>aid</td>
                <td>int(11)</td>
                <td>收款表期数</td>
            </tr>
            <tr>
                <td>money</td>
                <td>decimal(15,2)</td>
                <td>还款金额</td>
            </tr>
            <tr>
                <td>interest</td>
                <td>decimal(15,2)</td>
                <td>还款利息</td>
            </tr>
            <tr>
                <td>time</td>
                <td>int(11)</td>
                <td>还款时间</td>
            </tr>
            <tr id="collection">
                <td>type</td>
                <td>tinyint(1)</td>
                <td>状态</td>
            </tr>
            </tbody>
        </table><!--还款表 end--><!--收款表-->
        <table class="table table-bordered">
            <caption>collection(收款表<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>int(11)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>nper</td>
                <td>int(11)</td>
                <td>期数</td>
            </tr>
            <tr>
                <td>uid</td>
                <td>int(11)</td>
                <td>用户</td>
            </tr>
            <tr>
                <td>bid</td>
                <td>int(11)</td>
                <td>标ID</td>
            </tr>
            <tr>
                <td>fid</td>
                <td>int(11)</td>
                <td>交易对方期数</td>
            </tr>
            <tr>
                <td>money</td>
                <td>decimal(15,2)</td>
                <td>收款本息</td>
            </tr>
            <tr>
                <td>interest</td>
                <td>decimal(15,2)</td>
                <td>收款利息</td>
            </tr>
            <tr>
                <td>time</td>
                <td>int(11)</td>
                <td>收款时间</td>
            </tr>
            <tr id="overdue">
                <td>type</td>
                <td>tinyint(1)</td>
                <td>状态</td>
            </tr>
            </tbody>
        </table><!--收款表 end--><!--借款者逾期表-->
        <table class="table table-bordered">
            <caption>overdue(借款者逾期表<caption>)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>mediumint</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>uid</td>
                <td>int(11)</td>
                <td>用户ID</td>
            </tr>
            <tr>
                <td>bid</td>
                <td>int(11)</td>
                <td>标ID</td>
            </tr>
            <tr>
                <td>money</td>
                <td>decimal(15,2)</td>
                <td>逾期本息</td>
            </tr>
            <tr>
                <td>days</td>
                <td>tinyint(4)</td>
                <td>逾期天数</td>
            </tr>
            <tr>
                <td>type</td>
                <td>tinyint(1)</td>
                <td>状态</td>
            </tr>
            <tr id="coverdue">
                <td>time</td>
                <td>int(11)</td>
                <td>逾期时间</td>
            </tr>
            </tbody>
        </table><!--借款者逾期表 end--><!--投资者逾期表-->
        <table class="table table-bordered">
            <caption>coverdue(借款者逾期表)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>mediumint</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>uid</td>
                <td>int(11)</td>
                <td>用户ID</td>
            </tr>
            <tr>
                <td>bid</td>
                <td>int(11)</td>
                <td>标ID</td>
            </tr>
            <tr>
                <td>money</td>
                <td>int(11)</td>
                <td>逾期本息</td>
            </tr>
            <tr>
                <td>interest</td>
                <td>decimal(15,2)</td>
                <td>逾期利息</td>
            </tr>
            <tr>
                <td>days</td>
                <td>tinyint(4)</td>
                <td>逾期天数</td>
            </tr>
            <tr>
                <td>type</td>
                <td>tinyint(1)</td>
                <td>状态</td>
            </tr>
            <tr id="links">
                <td>time</td>
                <td>int(11)</td>
                <td>逾期时间</td>
            </tr>
            </tbody>
        </table><!--投资者逾期表 end--><!--友情链接-->
        <table class="table table-bordered">
            <caption>links(友情链接)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>int(11)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>title</td>
                <td>varchar(25)</td>
                <td>名称</td>
            </tr>
            <tr>
                <td>url</td>
                <td>varchar(255)</td>
                <td>链接</td>
            </tr>
            <tr>
                <td>state</td>
                <td>tinyint(1)</td>
                <td>状态</td>
            </tr>
            <tr>
                <td>time</td>
                <td>int(11)</td>
                <td>时间</td>
            </tr>
            <tr>
                <td>img</td>
                <td>varchar(25)</td>
                <td>图片</td>
            </tr>
            <tr id="shuffling">
                <td>order</td>
                <td>int(11)</td>
                <td>排序</td>
            </tr>
            </tbody>
        </table><!--友情链接 end--><!--轮播-->名称
        <table class="table table-bordered">
            <caption>shuffling(友情链接)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>int(11)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>title</td>
                <td>varchar(25)</td>
                <td></td>
            </tr>
            <tr>
                <td>type</td>
                <td>tinyint(1)</td>
                <td>类型</td>
            </tr>
            <tr>
                <td>state</td>
                <td>tinyint(1)</td>
                <td>状态</td>
            </tr>
            <tr>
                <td>time</td>
                <td>int(11)</td>
                <td>时间</td>
            </tr>
            <tr>
                <td>url</td>
                <td>varchar(255)</td>
                <td>URL</td>
            </tr>
            <tr>
                <td>img</td>
                <td>varchar(25)</td>
                <td>图片</td>
            </tr>
            <tr id="site">
                <td>order</td>
                <td>int(11)</td>
                <td>排序</td>
            </tr>
            </tbody>
        </table><!--轮播 end--><!--栏目表-->
        <table class="table table-bordered">
            <caption>site(栏目表)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>mediumint</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>order</td>
                <td>int(11)</td>
                <td>子类</td>
            </tr>
            <tr>
                <td>aid</td>
                <td>int(11)</td>
                <td>外键</td>
            </tr>
            <tr>
                <td>pid</td>
                <td>int(11)</td>
                <td>上级栏目id</td>
            </tr>
            <tr>
                <td>catpid</td>
                <td>varchar(100)</td>
                <td>id上下级对应关系</td>
            </tr>
            <tr>
                <td>title</td>
                <td>varchar(30)</td>
                <td>标题</td>
            </tr>
            <tr>
                <td>keyword</td>
                <td>varchar(100)</td>
                <td>搜索关键字</td>
            </tr>
            <tr>
                <td>remark</td>
                <td>varchar(200)</td>
                <td>描述/说明</td>
            </tr>
            <tr>
                <td>page_tpl</td>
                <td>varchar(50)</td>
                <td>封面模板</td>
            </tr>
            <tr>
                <td>list_tpl</td>
                <td>varchar(50)</td>
                <td>列表模板</td>
            </tr>
            <tr>
                <td>content_tpl</td>
                <td>varchar(50)</td>
                <td>内容模板</td>
            </tr>
            <tr>
                <td>link</td>
                <td>varchar(100)</td>
                <td>自定义链接</td>
            </tr>
            <tr>
                <td>user_id</td>
                <td>int(11)</td>
                <td>用户id</td>
            </tr>
            <tr>
                <td>status</td>
                <td>tinyint(1)</td>
                <td>状态</td>
            </tr>
            <tr>
                <td>type</td>
                <td>tinyint(1)</td>
                <td>类型</td>
            </tr>
            <tr>
                <td>orde</td>
                <td>int(11)</td>
                <td>排序</td>
            </tr>
            <tr id="site_add">
                <td>addtime</td>
                <td>char(10)</td>
                <td>添加时间</td>
            </tr>
            </tbody>
        </table><!--栏目表 end--><!--栏目表附加表-->
        <table class="table table-bordered">
            <caption>site_add(栏目表附加表)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>int(11)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>litpic</td>
                <td>varchar(150)</td>
                <td>栏目缩略图</td>
            </tr>
            <tr>
                <td>model</td>
                <td>varchar(50)</td>
                <td>调用模型</td>
            </tr>
            <tr>
                <td>uptime</td>
                <td>char(10)</td>
                <td>更新时间</td>
            </tr>
            <tr>
                <td>upid</td>
                <td>int(11)</td>
                <td>更新者id</td>
            </tr>
            <tr>
                <td>upip</td>
                <td>varchar(20)</td>
                <td>更新者ip</td>
            </tr>
            <tr id="article">
                <td>content</td>
                <td>text</td>
                <td>栏目内容</td>
            </tr>
            </tbody>
        </table><!--栏目表附加表 end--><!--文章表-->
        <table class="table table-bordered">
            <caption>article(文章表)</caption>
            <thead>
            <tr class="success">
                <th style="width:300px;">名字</th>
                <th style="width:300px;">类型</th>
                <th>说明</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>id</td>
                <td>int(11)</td>
                <td>主键</td>
            </tr>
            <tr>
                <td>fid</td>
                <td>int(11)</td>
                <td>外键</td>
            </tr>
            <tr>
                <td>title</td>
                <td>varchar(30)</td>
                <td>标题</td>
            </tr>
            <tr>
                <td>introtext</td>
                <td>mediumtext</td>
                <td>文章正文</td>
            </tr>
            <tr>
                <td>published</td>
                <td>tinyint(1)</td>
                <td>是否发布</td>
            </tr>
            <tr>
                <td>catid</td>
                <td>int(11)</td>
                <td>对应栏目id</td>
            </tr>
            <tr>
                <td>user_id</td>
                <td>int(11)</td>
                <td>作者id</td>
            </tr>
            <tr>
                <td>order</td>
                <td>int(11)</td>
                <td>排序</td>
            </tr>
            <tr>
                <td>access</td>
                <td>tinyint(1)</td>
                <td>访问级别</td>
            </tr>
            <tr>
                <td>is_comment</td>
                <td>tinyint(1)</td>
                <td>是否允许评论</td>
            </tr>
            <tr>
                <td>keyword</td>
                <td>varchar(100)</td>
                <td>关键字</td>
            </tr>
            <tr>
                <td>remark</td>
                <td>varchar(200)</td>
                <td>描述</td>
            </tr>
            <tr id="article_add">
                <td>addtime</td>
                <td>char(10)</td>
                <td>添加时间</td>
            </tr>
            </tbody>
        </table><!--文章表 end--><!--文章附加表-->
        <table class="table table-bordered">
        	<caption>article_add(文章附加表)</caption>
        	<thead>
        	<tr class="success">
        		<th style="width:300px;">名字</th>
        		<th style="width:300px;">类型</th>
        		<th>说明</th>
        	</tr>
        	</thead>
        	<tbody>
        	<tr>
        		<td>id</td>
        		<td>int(11)</td>
        		<td>主键</td>
        	</tr>
        	<tr>
        		<td>modified</td>
        		<td>char(10)</td>
        		<td>修改时间</td>
        	</tr>
        	<tr>
        		<td>modified_by</td>
        		<td>int(11)</td>
        		<td>修改者编号</td>
        	</tr>
        	<tr>
        		<td>hits</td>
        		<td>int(11)</td>
        		<td>文章点击数</td>
        	</tr>
        	<tr>
        		<td>upid</td>
        		<td>int(11)</td>
        		<td>更新者id</td>
        	</tr>
        	<tr>
        		<td>Integration</td>
        		<td>int(11)</td>
        		<td>文章的积分</td>
        	</tr>
        	<tr>
        		<td>comment</td>
        		<td>int(11)</td>
        		<td>评论数</td>
        	</tr>
        	<tr>
        		<td>litpic</td>
        		<td>varchar(150)</td>
        		<td>文章缩略图</td>
        	</tr>
        	</tbody>
        </table>
		
		
		<table class="table table-bordered">
			<caption>redpacket(红包表)</caption>
			<thead>
			<tr class="success">
				<th style="width:300px;">名字</th>
				<th style="width:300px;">类型</th>
				<th>说明</th>
			</tr>
			</thead>
			<tbody>
			<tr>
				<td>id</td>
				<td>int(11)</td>
				<td>主键</td>
			</tr>
			<tr>
				<td>name</td>
				<td>varchar(20)</td>
				<td>红包名称</td>
			</tr>
			<tr>
				<td>money</td>
				<td>int(11)</td>
				<td>红包金额</td>
			</tr>
			<tr>
				<td>number</td>
				<td>int(11)</td>
				<td>红包数量</td>
			</tr>
			<tr>
				<td>conditions</td>
				<td>int(11)</td>
				<td>红包描述</td>
			</tr>
			<tr>
				<td>starttime</td>
				<td>int(11)</td>
				<td>开始时间</td>
			</tr>
			<tr>
				<td>endtime</td>
				<td>int(11)</td>
				<td>结束时间</td>
			</tr>
			<tr>
				<td>state</td>
				<td>varchar(150)</td>
				<td>红包状态</td>
			</tr>
			<tr>
				<td>minmoney</td>
				<td>varchar(150)</td>
				<td>红包最小生效金额</td>
			</tr>
			<tr>
				<td>maxmoney</td>
				<td>varchar(150)</td>
				<td>红包最大生效金额</td>
			</tr>
			<tr>
				<td>isinvest</td>
				<td>varchar(150)</td>
				<td>是否投资红包</td>
			</tr>
			</tbody>
		</table>
		
		
		<table class="table table-bordered">
			<caption>redpacket_log(红包日志表)</caption>
			<thead>
			<tr class="success">
				<th style="width:300px;">名字</th>
				<th style="width:300px;">类型</th>
				<th>说明</th>
			</tr>
			</thead>
			<tbody>
			<tr>
				<td>id</td>
				<td>int(11)</td>
				<td>主键</td>
			</tr>
			<tr>
				<td>uid</td>
				<td>varchar(20)</td>
				<td>人id</td>
			</tr>
			<tr>
				<td>rid</td>
				<td>int(11)</td>
				<td>红包id</td>
			</tr>
			<tr>
				<td>name</td>
				<td>int(11)</td>
				<td>红包名称</td>
			</tr>
			<tr>
				<td>money</td>
				<td>int(11)</td>
				<td>红包金额</td>
			</tr>
			<tr>
				<td>conditions</td>
				<td>int(11)</td>
				<td>红包描述</td>
			</tr>
			<tr>
				<td>time</td>
				<td>int(11)</td>
				<td>发红包时间</td>
			</tr>
			<tr>
				<td>state</td>
				<td>varchar(150)</td>
				<td>状态</td>
			</tr>
			
			</tbody>
		</table>
		
		
		
		
		
		<!--文章附加表 end--></div><!--内容 end--></div>
		
		
<script src="bootstrap.min.js"></script>
</body>
</html>